Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Developers List" <torque-dev@db.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
Message-ID: <001701c50bc0$1156ba50$8e00a8c0@Jaguar>
From: "Ely Rances" <erances@exist.com>
To: <torque-dev@db.apache.org>
Subject: Error in using Derby and Cloudscape as Database Adapter
Date: Sat, 5 Feb 2005 12:19:51 -0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0014_01C50B7C.FE03A870"
Disposition-Notification-To: "Ely Rances" <erances@exist.com>

------=_NextPart_000_0014_01C50B7C.FE03A870
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Exist Softwarelabs
Hi,

We are currently using derby torque adapter.
We have set one of our properties file, adapter to derby,=20
and used the derby-torque from HEAD and build with the=20
following jar files as result:
1.) torque-3.2-dev.jar
2.) torque-gen-3.2-dev.jar
3.) maven-torque-plugin-3.2-dev.jar

After running our application.
It did not connect to the derby database, instead we came with the =
following errors:

      There has been an Error!
      Reason:=20
        java.lang.Error: Error in =
BasePeer.initTableSchema(TURBINE_USER): There was no DataSourceFactory =
configured for the connection default
      =20


      Get/Post Data:
            template  =3D ShowError.vm=20

    =20


      Stacktrace:
     =20
          java.lang.Error: Error in =
BasePeer.initTableSchema(TURBINE_USER): There was no DataSourceFactory =
configured for the connection default
	at =
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initClass(Bas=
eTurbineUserPeer.java:154)
	at =
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.(BaseTurbineU=
serPeer.java:128)
	at =
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUs=
er(TurbineUserManagement.java:136)
	at =
org.apache.jetspeed.services.JetspeedUserManagement.getUser(JetspeedUserM=
anagement.java:59)
	at =
org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAn=
onymousUser(TurbineAuthentication.java:188)
	at =
org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(Jets=
peedAuthentication.java:64)
	at =
org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSe=
curity.java:134)
	at =
org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(Te=
mplateSessionValidator.java:59)
	=20


However, when we tried setting cloudscape in one of our properties file, =
(as adapter).
It was able to connect to derby database, but we encountered the =
following errors:


      There has been an Error!
      Reason:=20
        org.apache.jetspeed.services.security.LoginException: Failed to =
get anonymous user: : Failed to retrieve roles : SQL Exception: =
Comparisons between 'INTEGER' and 'CHAR' are not supported.
      =20


      Get/Post Data:
            template  =3D ShowError.vm=20

    =20


      Stacktrace:
     =20
          org.apache.torque.TorqueException: SQL Exception: Comparisons =
between 'INTEGER' and 'CHAR' are not supported.
	at =
org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
	at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1550)
	at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1391)
	at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1368)
	at =
org.apache.jetspeed.om.security.turbine.BaseTurbineUserGroupRolePeer.doSe=
lectVillageRecords(BaseTurbineUserGroupRolePeer.java:369)
	at =
org.apache.jetspeed.om.security.turbine.BaseTurbineUserGroupRolePeer.doSe=
lectVillageRecords(BaseTurbineUserGroupRolePeer.java:337)
	at =
org.apache.jetspeed.om.security.turbine.BaseTurbineUserGroupRolePeer.doSe=
lect(BaseTurbineUserGroupRolePeer.java:306)
	at =
org.apache.jetspeed.services.security.turbine.TurbineRoleManagement.getRo=
les(TurbineRoleManagement.java:123)
	at =
org.apache.jetspeed.services.security.JetspeedRoleManagement.getRoles(Jet=
speedRoleManagement.java:64)
	at =
org.apache.jetspeed.services.JetspeedSecurity.getRoles(JetspeedSecurity.j=
ava:299)
	at =
org.apache.jetspeed.services.security.SecurityCacheImpl.load(SecurityCach=
eImpl.java:85)
	at =
org.apache.jetspeed.services.security.JetspeedSecurityCache.load(Jetspeed=
SecurityCache.java:66)
	at =
org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAn=
onymousUser(TurbineAuthentication.java:193)
	at =
org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(Jets=
peedAuthentication.java:64)
	at =
org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSe=
curity.java:134)
	at =
org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(Te=
mplateSessionValidator.java:59)
	=20


It seems here that with cloudscape as adapter, it retrieves the inserted =
INTEGER data as CHAR?
Has anyone of you encountered such errors, especially the latter =
one(cloudscape) ?


TIA


------=_NextPart_000_0014_01C50B7C.FE03A870--