any body tried connection pooling with gupta sqlbase server
james george
<Dec 18, 2004 3:15:45 PM PST> <Error> <JDBC> <BEA-001150> <Connection Pool
"ebs"
deployment failed with the following error: No registered driver accepts
URL: j
dbc:sqlbase://localhost:2155/ISLAND.>
Any help is appreciated.
Thanks
James
Joe Weinstein
or show me any simple example code that makes a connection to the
DBMS you want, using the driver you want?
thanks,
Joe
james george
-------------------------------------------------------
/**
* Copyright (c) 2002 Gupta Technologies, LLC. All Rights Reserved.
*
*
* This program fetches Result Set meta data
*
*/
import java.io.*;
import java.util.*;
import java.sql.*;
public class ResultSetMeta
{
private static String url = "jdbc:sqlbase://localhost:2155/ISLAND";
public static void main (String args[])
{ try
{
Class.forName("jdbc.gupta.sqlbase.SqlbaseDriver");
if ( args.length > 0 &&
args[0].length() > 0)
{
url = args[0];
} // ENDIF Get Connection URL
Connection con1 = DriverManager.getConnection(url, "SYSADM", "SYSADM");
Statement stmt = con1.createStatement( );
try
{ stmt.executeUpdate("drop table foo");
} catch (Exception e)
{ System.out.println("e = " + e.getMessage());
}
stmt.executeUpdate("Create table foo (c1 int, c2 char(100))");
con1.commit();
System.out.println("Will insert three rows into the empty table foo and
commit it.\n");
stmt.executeUpdate( "Insert into foo values(101,'HHH')");
stmt.executeUpdate( "Insert into foo values(102,'III')");
stmt.executeUpdate( "Insert into foo values(103,'JJJ')");
Statement stmt1 = con1.createStatement();
ResultSet rs = stmt1.executeQuery("select * from foo");
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
while (rs.next())
{ for (int i = 1; i<= numberOfColumns; i++)
{ int jdbcType = rsmd.getColumnType(i);
String name = rsmd.getColumnTypeName(i);
String s = rs.getString(i);
System.out.println("Column " + i + ": " + name + " -- " + jdbcType +
" -- " + s);
System.out.println(" ");
}
}
con1.commit();
stmt.close();
con1.close();
} catch (Exception ex)
{ System.out.println("Exception in main: " + ex);
}
}
}
----------------------------------------------------------------------------
"Joe Weinstein" <joeN...@bea.com> wrote in message
news:41C494A7...@bea.com...
Joe Weinstein
OK, then edit the config.xml file to add this pool,
and let me know if it works. However, first tell
me if you can run that program. If you can, show me
your PATH and CLASSPATH. The classpath the server
gets from the startWebLogic script will have to have
everything the driver needs, and if this driver
is a type-2 driver, the server's PATH will need
everything your successful path has. Let me know...
Joe
<JDBCConnectionPool
DriverName="jdbc.gupta.sqlbase.SqlbaseDriver"
MaxCapacity="1"
InitialCapacity="1"
Name="guptaPool"
Properties="user=SYSADM;password=SYSADM"
URL="jdbc:sqlbase://localhost:2155/ISLAND"
Targets="examplesServer"
/>
Edit your Target entry...
Joe
james george
Thanks for your reply.
I dont set any path to run the sample program.
See the classpath below.
G:\Program Files\Gupta\SQLBase90\samples\jdbc>javac Res.java
G:\Program Files\Gupta\SQLBase90\samples\jdbc>java -cp "G:\Program
Files\Gupta\S
QLBase90\java\SQLBaseJDBC.jar";. Res
Will insert three rows into the empty table foo and commit it.
Column 1: INTEGER -- 4 -- 101
Column 2: CHAR -- 1 -- HHH
Column 1: INTEGER -- 4 -- 102
Column 2: CHAR -- 1 -- III
Column 1: INTEGER -- 4 -- 103
Column 2: CHAR -- 1 -- JJJ
-----------------------------------------------------------
I am still getting the exception
<Dec 21, 2004 12:11:45 AM PST> <Error> <JDBC> <BEA-001150> <Connection Pool
"gup
taPool" deployment failed with the following error: No registered driver
accepts
URL: jdbc:sqlbase://localhost:2155/ISLAND.>
---------------------------------------------------------
Here is my weblogic path
CLASSPATH=G:\bea\weblogic81\server\lib\SQLBaseJDBC.jar;WL_HOME\server\lib\we
blog
ic.jar;G:\bea\JDK142~1\lib\tools.jar;G:\bea\WEBLOG~1\server\lib\weblogic_sp.
jar;
G:\bea\WEBLOG~1\server\lib\weblogic.jar;G:\bea\WEBLOG~1\common\eval\pointbas
e\li
b\pbserver44.jar;G:\bea\WEBLOG~1\common\eval\pointbase\lib\pbclient44.jar;G:
\bea
\JDK142~1\jre\lib\rt.jar;G:\bea\WEBLOG~1\server\lib\webservices.jar;"g:\Prog
ram
Files\Gupta\SQLBase90\java\SQLBaseJDBC.jar";C:\Program
Files\Altova\xmlspy\XMLSp
yInterface.jar
.
PATH=G:\bea\WEBLOG~1\server\bin;G:\bea\JDK142~1\jre\bin;G:\bea\JDK142~1\bin;
C:\W
INNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\IBM\SQLLIB\BIN;C:\IBM\SQLLI
B\FU
NCTION;C:\IBM\SQLLIB\SAMPLES\REPL;G:\jdk\bin;G:\bea\WEBLOG~1\server\bin\oci9
20_8
----------------------------------------------------
"Joe Weinstein" <joeN...@bea.com> wrote in message
news:41C6753E...@bea.com...
Joe Weinstein
james george wrote:
> Hi,
>
> Thanks for your reply.
> I dont set any path to run the sample program.
> See the classpath below.
>
> G:\Program Files\Gupta\SQLBase90\samples\jdbc>javac Res.java
>
> G:\Program Files\Gupta\SQLBase90\samples\jdbc>java -cp "G:\Program
> Files\Gupta\S
> QLBase90\java\SQLBaseJDBC.jar";. Res
> Will insert three rows into the empty table foo and commit it.
Ok, do these things:
1 - Make sure the SQLBaseJDBC.jar listed above is the same as the
\bea\weblogic81\server\lib\SQLBaseJDBC.jar.
2 - Edit the start-weblogic script to see how it constructs it's
own -classpath argument to start weblogic, and make sure that
argument includes "\bea\weblogic81\server\lib\SQLBaseJDBC.jar".
3 - then let me know what happens when the server boots up trying to
make the pool.
Joe
james george
:MaxPermSize=128m -cp "G:\Program Files\Gupta\SQLBase90\java\SQLBaseJDBC.jar";"G
:\bea\jdk142_04\lib\tools.jar";"G:\bea\weblogic81\server\lib\weblogic.jar";"G:\b
ea\jdk142_04\lib\rt.jar" -Dweblogic.Name=myserver -Dweblogic.ProductionModeEnabl
ed= -Djava.security.policy="G:\bea\weblogic81\server\lib\weblogic.policy" weblog
ic.Server > p.txt
[Loaded jdbc.gupta.sqlbase.SqlbaseDriver]
[Loaded jdbc.gupta.sqlbase.SqlbaseErrorMessages]
[Loaded java.sql.Connection from G:\bea\JDK142~1\jre\lib\rt.jar]
[Loaded java.sql.DriverManager from G:\bea\JDK142~1\jre\lib\rt.jar]
[Loaded java.sql.SQLPermission from G:\bea\JDK142~1\jre\lib\rt.jar]
[Loaded java.sql.DriverInfo from G:\bea\JDK142~1\jre\lib\rt.jar]
[Loaded weblogic.jdbc.common.internal.JDBCResourceFactory]
[Loaded weblogic.jdbc.common.internal.JDBCResourceFactoryImpl]
[Loaded weblogic.jdbc.common.internal.ConnectionEnvFactory]
[Loaded weblogic.jdbc.common.internal.ConnectionState]
[Loaded java.sql.SQLWarning from G:\bea\JDK142~1\jre\lib\rt.jar]
<Dec 22, 2004 11:36:53 PM PST> <Error> <JDBC> <BEA-001150> <Connection Pool "guptaPool" deployment failed with the following error: No registered driver accepts URL: jdbc:sqlbase://localhost:2155/ISLAND.>
Joe Weinstein
james george wrote:
> I did this way and still get the same exception.
Ok, what version of weblogic is this? I'll make a debug patch...
Joe
> "Joe Weinstein" <joeN...@bea.com <mailto:joeN...@bea.com>> wrote in
> > > "Joe Weinstein" <joeN...@bea.com <mailto:joeN...@bea.com>>
> > >>>"Joe Weinstein" <joeN...@bea.com <mailto:joeN...@bea.com>>
james george
I am on windows 2000 machine
"Joe Weinstein" <joeN...@bea.com> wrote in message
news:41CA529B...@bea.com...
james george
JDBC log stream started at Tue Dec 28 23:57:58 PST 2004
-------------------------------------------------------------
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver:
driver[className=jdbc.gupta.sqlbase.SqlbaseDriver,jdbc.gupta.sqlbase.Sqlbase
Driver@825cf3]
DEBUG CONENVFAC: Loading driver jdbc.gupta.sqlbase.SqlbaseDriver
DEBUG CONENVFAC: with URL jdbc:sqlbase://localhost:2155/ISLAND
registerDriver:
driver[className=jdbc.gupta.sqlbase.SqlbaseDriver,jdbc.gupta.sqlbase.Sqlbase
Driver@172290f]
DEBUG CONENVFAC: driver jdbc.gupta.sqlbase.SqlbaseDriver is instantiated
DEBUG CONENVFAC: driver.acceptsURL()? false
DriverManager.getDriver("jdbc:sqlbase://localhost:2155/ISLAND")
trying
driver[className=jdbc.gupta.sqlbase.SqlbaseDriver,jdbc.gupta.sqlbase.Sqlbase
Driver@825cf3]
trying
driver[className=jdbc.gupta.sqlbase.SqlbaseDriver,jdbc.gupta.sqlbase.Sqlbase
Driver@172290f]
getDriver: no suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:243)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.loadDriver(ConnectionEnvF
actory.java:51)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.<init>(ConnectionEnvFacto
ry.java:105)
at
weblogic.jdbc.common.internal.ConnectionPool.initPooledResourceFactory(Conne
ctionPool.java:617)
at
weblogic.common.resourcepool.ResourcePoolImpl.start(ResourcePoolImpl.java:16
6)
at
weblogic.jdbc.common.internal.ConnectionPool.doStart(ConnectionPool.java:100
1)
at
weblogic.jdbc.common.internal.ConnectionPool.start(ConnectionPool.java:142)
at
weblogic.jdbc.common.internal.ConnectionPoolManager.createAndStartPool(Conne
ctionPoolManager.java:298)
at
weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.java:180
)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
arget.java:331)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
Target.java:591)
at
weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
eploymentTarget.java:569)
at
weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
entTarget.java:241)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
.java:731)
at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
10)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
nImpl.java:484)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
at
weblogic.management.internal.RemoteMBeanServerImpl.private_invoke(RemoteMBea
nServerImpl.java:985)
at
weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
mpl.java:943)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
at
weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
:481)
at
weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
Bean_Stub.java:7351)
at
weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
Deployer.java:1304)
at
weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:347
)
at
weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
ymentManagerServerLifeCycleImpl.java:229)
at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:966)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:361)
at weblogic.Server.main(Server.java:32)
SQLException: SQLState(08001)
"Joe Weinstein" <joeN...@bea.com> wrote in message
news:41D19A03...@bea.com...
>
>
> james george wrote:
>
> > Domain ConfigurationVersion="8.1.3.0".
> >
> > I am on windows 2000 machine
> > "Joe Weinstein" <joeN...@bea.com> wrote in message
> > news:41CA529B...@bea.com...
>
> Hi. Here's a one-off debug patch. Make sure it's ahead of weblogic.jar in
> the classpath created in the start-weblogic script. Please turn on jdbc
logging,
> and reproduce the problem. Show me the jdbc log file. It will print out
stuff.
> Joe
Joe Weinstein
'acceptsURL( String URL)' which a driver has, which says (obviously) whether it
accepts a given URL. Apparently the gupta driver returns false with the URL
you sent it. Please try this code in a simple standalone program:
java.sql.Driver dd =
(java.sql.Driver)Class.forName("jdbc.gupta.sqlbase.SqlbaseDriver").newInstance();
System.out.println("Does the gupta driver accept my URL? "
+ dd.acceptsURL( "jdbc:sqlbase://localhost:2155/ISLAND" );
java.sql.DriverManager.getConnection( "jdbc:sqlbase://localhost:2155/ISLAND", myUser, myPassword);
If it says false, then either your URL is wrong, or the driver method is broken.
If the subsequent getConnection() method succeeds, then it proves the acceptsURL()
method is broken.
Mitesh Patel
Mitesh
Mitesh Patel
Did my suggetion worked for you? Please let me know.
Can you test with URL i have suggested without port number and see if it works?
Thanks,
Mitesh