|
Home > Archive > EAserver > December 2005 > Connect to database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Connect to database
|
|
| Jesus Campos 2005-12-21, 9:24 am |
| Hi,
I use EAServer 5.2 and on jsp script I try to connect to a databse ASA 8 by
JDBC with the next code:
PSConnectionClass myconnect;
try {
myconnect = new PSConnectionClass(pa
geContext,
"com.sybase.jdbc2.jdbc.SybDriver", "jdbc:sybase:Tds:10.53.x.x:2653", "dba",
"xxx", true);
} catch( Exception e ){
out.println(" Error : " + e.toString() );
myconnect = null;
}
if ( myconnect.GetError() == null && myconnect != null){
(....)
}
But the server only report this:
500 Servlet jspservlet: unable to service request:
com/sybase/powerbuilder/jdbc/PbjdbcSession
I'm doing some wrong? What I can do to see the full error message?
Thanks.
| |
| Jim O'Neil [Sybase] 2005-12-21, 8:25 pm |
| I'm not sure why you can't see the entire message, but I'd say that
the problem is in locating the PBJDBCxx.JAR file in the CLASSPATH and
possibly BOOTCLASSPATH
On 21 Dec 2005 06:23:03 -0800, "Jesus Campos"
<jesus.gi@cm-barcelos.pt> wrote:
>Hi,
>I use EAServer 5.2 and on jsp script I try to connect to a databse ASA 8 by
>JDBC with the next code:
>
> PSConnectionClass myconnect;
> try {
>
> myconnect = new PSConnectionClass(pa
geContext,
>"com.sybase.jdbc2.jdbc.SybDriver", "jdbc:sybase:Tds:10.53.x.x:2653", "dba",
>"xxx", true);
>
> } catch( Exception e ){
> out.println(" Error : " + e.toString() );
> myconnect = null;
> }
>
> if ( myconnect.GetError() == null && myconnect != null){
> (....)
> }
>
>But the server only report this:
>500 Servlet jspservlet: unable to service request:
>com/sybase/powerbuilder/jdbc/PbjdbcSession
>I'm doing some wrong? What I can do to see the full error message?
>
>Thanks.
>
>
>
| |
| Jesus Campos 2005-12-22, 7:24 am |
| Hi, thanks for reply.
You are right, no one PBJDBCxx.JAR are in CLASSPATH or BOOTCLASSPATH. I copy
"pbjdbc1290.jar" to "../sybase/EAServer/java/lib" directory, but now, I
don't know how I can change the general properties of EAServer. I already
try at "../sybase/EAServer/Repository/Server/Jaguar.props" but I find not
CLASSPATH or BOOTCLASSPATH properties.
"Jim O'Neil [Sybase]" < joneil_at_sybase_dot
_com> escreveu na mensagem
news:1dojq19q54k2uhh
9imgfjit1k08k5hd3i9@
4ax.com...
> I'm not sure why you can't see the entire message, but I'd say that
> the problem is in locating the PBJDBCxx.JAR file in the CLASSPATH and
> possibly BOOTCLASSPATH
>
> On 21 Dec 2005 06:23:03 -0800, "Jesus Campos"
> <jesus.gi@cm-barcelos.pt> wrote:
>
>
| |
| Jim O'Neil [Sybase] 2005-12-22, 11:24 am |
| If you are starting as a console app, putting the JAR in the java/lib
directory will automatically add it to CLASSPATH. The CLASSPATH and
BOOTCLASSPATH are not Jaguar properties but rather system environment
variables.
On 22 Dec 2005 03:19:00 -0800, "Jesus Campos"
<jesus.gi@cm-barcelos.pt> wrote:
>Hi, thanks for reply.
>
>
>
>You are right, no one PBJDBCxx.JAR are in CLASSPATH or BOOTCLASSPATH. I copy
>"pbjdbc1290.jar" to "../sybase/EAServer/java/lib" directory, but now, I
>don't know how I can change the general properties of EAServer. I already
>try at "../sybase/EAServer/Repository/Server/Jaguar.props" but I find not
>CLASSPATH or BOOTCLASSPATH properties.
>
>
>
>"Jim O'Neil [Sybase]" < joneil_at_sybase_dot
_com> escreveu na mensagem
> news:1dojq19q54k2uhh
9imgfjit1k08k5hd3i9@
4ax.com...
>
|
|
|
|
|