Try connecting the db with a simple java class. This will give You more
information.
I use this to check the connection:
import java.sql.*;
public final class db {
private static Connection connection = null;
private static Statement statement = null;
public static void main(String _[]) {
log("Downloading the driver...");
try {
Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
connection =
DriverManager.getConnection("jdbc:sybase:Tds:localhost:2638/census_file_db",
"dba","sql");
statement = connection.createStatement();
} catch (Exception e) {
e.printStackTrace();
}
.....
}
> -----Original Message-----
> From: Guy Rouillier [SMTP:[EMAIL PROTECTED]]
> Sent: 19 June 2001 09:37
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-user] Sybase Datasource problem
>
> Hangs at startup time are usually due to incorrect
> connection/authentication
> data in jboss.jcml. The pool code attempts to establish a connection at
> startup time. If the connect data is incorrect, the connection cannot be
> established.
>
> ----- Original Message -----
> From: "John DeStefano" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, June 18, 2001 1:25 PM
> Subject: [JBoss-user] Sybase Datasource problem
>
>
> Hi,
>
> I'm having a problem with creating a Sybase connection pool. I'm using
> JBoss
> 2.2.2 and JDK1.3.1. The startup output looks like this:
>
> [JNDIView] Starting
> [JNDIView] Started
> [Transaction manager] Starting
> [Transaction manager] Started
> [JAAS Security Manager] Starting
> [JAAS Security Manager] JAAS.startService, cachePolicy=null
> [JAAS Security Manager] JAAS.startService,
> SecurityProxyFactory=org.jboss.security.SubjectSecurityProxyFactory@4b6009
> [JAAS Security Manager] Started
> [JDBC provider] Starting
> [JDBC provider] Started
> [Hypersonic] Starting
> [Hypersonic] Database started
> [Hypersonic] Started
> [DefaultDS] Starting
> [Hypersonic] Server 1.4 is running
> [Hypersonic] Press [Ctrl]+[C] to abort
> [DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS
> [DefaultDS] Started
> [CensusDS] Starting
> [CensusDS] XA Connection pool CensusDS bound to java:/CensusDS
>
> It hangs at the attempt to bind the Sybase datasource.
>
> The jboss.jcml section for the sysbase database looks like this:
>
> <mbean code="org.jboss.jdbc.XADataSourceLoader"
> name="DefaultDomain:service=XADataSource,name=CensusDS">
> <attribute name="PoolName">CensusDS</attribute>
> <attribute
> name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceI
> mp
> l</attribute>
> <attribute
> name="URL">jdbc:sybase:Tds:localhost:2638/census_file_db</attribute>
> <attribute name="JDBCUser">dba</attribute>
> <attribute name="MaxSize">2</attribute>
> <attribute name="MinSize">1</attribute>
> <attribute name="Password">sql</attribute>
> <attribute name="Properties"></attribute>
> <attribute name="GCEnabled">false</attribute>
> <attribute name="InvalidateOnError">false</attribute>
> <attribute name="TimestampUsed">false</attribute>
> <attribute name="Blocking">true</attribute>
> <attribute name="GCInterval">120000</attribute>
> <attribute name="IdleTimeout">1800000</attribute>
> <attribute name="IdleTimeoutEnabled">false</attribute>
> <attribute name="LoggingEnabled">false</attribute>
> <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> </mbean>
>
> The sybase driver does load according to the server startup output.
>
> Any help would be appreciated.
>
> Thanks
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
